Mega Code Archive

Categories
1) Android
2) ASP.Net
3) ASP.Net Tutorial
4) C
5) C Tutorial
6) C#
7) C# Book
8) C# by API
9) C# Tutorial
10) C++
11) C++ Tutorial
12) Delphi
13) Flash ActionScript
14) Flex
15) Java
16) Java Book
17) Java by API
18) Java Tutorial
19) JavaScript DHTML
20) JavaScript Reference
21) JavaScript Tutorial
22) MSOfficeExcel 2007 Tutorial
23) MSOfficePowerPoint 2007 Tutorial
24) MSOfficeWord 2007 Tutorial
25) MSSQL
26) MSSQL Tutorial
27) MySQL
28) MySQL Tutorial
29) Oracle PLSQL
30) Oracle PLSQL Tutorial
31) Perl
32) Php
33) PostgreSQL
34) Python
35) Python Tutorial
36) Ruby
37) Silverlight
38) VB.Net
39) VB.Net by API
40) VB.Net Tutorial
41) Visual C++ .NET
42) VisualBasic Script
43) XML
44) XML Tutorial

 

MySQL Tutorial
1) Aggregate Functions
2) Cast Functions Operators
3) Comparison Functions Operators
4) Control Flow Functions
5) Cursor
6) Data Dictionary
7) Data Types
8) Database
9) Date Time Functions
10) Encryption Compression Functions
11) Information Functions
12) Insert Update Delete
13) Introduction
14) Logic Operator
15) Math Numeric Functions
16) Miscellaneous Functions
17) MySQL Utilities
18) Privilege
19) Procedure Function
20) Regular Expressions
21) Select Query
22) String Functions
23) Subquery
24) Table
25) Table Join
26) Trigger
27) View

Comparison Functions Operators
1) Check to see if the first name is NULL
2) Compare string value using the Greater than ( = ) operator
3) Compare string value using the Greater than or equal( = )
4) Compare string value using the Less than or equal(=) operator
5) Compare string value using the Less than( ) operator
6) Compare string value using the Not equal operator
7) Comparing integer value with less than operator
8) Comparison Functions and Operators
9) Data type conversion in Not equal operator
10) Equal
11) Expr BETWEEN min AND max
12) Expr IN (value, )
13) Greater than
14) Greater than or equal
15) GREATEST(@id1, @id2, @id3, @id4, @id5)
16) GREATEST(value1,value2, ) returns NULL if any argument is NULL
17) GREATEST(value1,value2, ) returns the largest (maximum-valued) argument within two or more arguments
18) INTERVAL(N,N1,N2,N3, )
19) IS boolean_value
20) IS NOT boolean_value
21) IS NOT NULL
22) IS NULL
23) ISNULL(expr)
24) LEAST with float value
25) LEAST() returns NULL if any argument is NULL
26) LEAST(value1,value2, ) returns the smallest (minimum-valued) argument withing two or more arguments
27) Less than
28) Less than or equal
29) Not equal
30) NULL-safe equal
31) SELECT 0 0 = 0
32) SELECT 0 01 = 0
33) SELECT 01 0 01
34) SELECT 2 BETWEEN 2 AND 3
35) SELECT 2 BETWEEN 2 AND x-3
36) SELECT A IN (A,B,C)
37) SELECT b BETWEEN a AND c
38) SELECT COALESCE(NULL,NULL,NULL)
39) SELECT GREATEST(3 0,3 0,5 0,7 0)
40) SELECT GREATEST(B,A,C)
41) SELECT ISNULL(10)
42) String comparisons are not case sensitive
43) Type conversion when using the Equal operator
44) Use GREATEST(value1,value2, ) function with column data
45) Use IN with data in a table
46) Use LEAST with data in a table
47) Using IN with subquery
48) Using ISNULL in where clause
49) Using ISNULL with data in a table
50) Using LEAST with string value
51) Using more than one column with a NOT IN operator
52) You should never mix quoted and unquoted values in an IN list